Column oriented compilation of variant tables
نویسنده
چکیده
The objective of this work is to improve variant table evaluation in a configurator by compiling/compressing the tables individually to reduce both processing time and space. The main result is a proposed simple heuristic for decomposing the variant table into subtables and a representation linking these subtables in a directed acyclic graph (DAG). The size of the compression obtained by this heuristic for examples used in [2, 10] is comparable to that achieved there. However, a formal analysis of complexity has not yet been completed. A prototype implemented in Java exists. Objectives in designing it were to keep it completely decoupled from any particular configurator, while using little machinery in order to keep software maintenance costs low. Testing both on abstract examples and on tables that resemble real customer data is ongoing and looks promising. Non-atomic table cells (such as real intervals, or value sets) are supported. My approach to negative variant tables [8] has been incorporated into the implementation.
منابع مشابه
Modeling and Simulation of a Divided Wall Column for 1,3 Butadiene Purification
The distillation process remains as the most common method ofseparation in chemical process industries. The energy used from this process accounts for an estimated 3% of <span style="font-size: 10pt; c...
متن کاملColumn Stores for Wide and Sparse Data
While it is generally accepted that data warehouses and OLAP workloads are excellent applications for column-stores, this paper speculates that column-stores may well be suited for additional applications. In particular we observe that column-stores do not see a performance degradation when storing extremely wide tables, and column-stores handle sparse data very well. These two properties lead ...
متن کاملGender-oriented Commonalities among Canadian and Iranian Englishes: An Analysis of Yes/No Question Variants
This study investigatesvariability in English yes/no questions as well as the commonalities among yes/no question variants produced by members of two different varieties of English: Canadian English native speakers and Iranian EFL learners.Further, it probes the role of gender in theEnglish yes/no question variants produced by Canadian English native speakers and those produced by Iranian EFL l...
متن کاملReal-Time Analytical Processing with SQL Server
Over the last two releases SQL Server has integrated two specialized engines into the core system: the Apollo column store engine for analytical workloads and the Hekaton in-memory engine for high-performance OLTP workloads. There is an increasing demand for real-time analytics, that is, for running analytical queries and reporting on the same system as transaction processing so as to have acce...
متن کاملA new approach for database “Column-oriented DBMS”
As we all know that many different kind of organization need database for required information from different area like analytic, different types of reports and other many reasons. As the organization grows the database also grow into millions of records spared over many tables and business intelligent/science. And if any organization want any specific report strategic analysis, and other busin...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
عنوان ژورنال:
دوره شماره
صفحات -
تاریخ انتشار 2015